** Connect to Data Sources **
"
The first step is to connect to the data
We had 3 different data sources:
1) MBS #1
2) MBS #2
3) Unemployment Rates
MBS stands for Mortgage backed security. The MBS data sets are the underlying records of the mortgages that comprise the security. Each one has the fields:
-ID (#)
-Occupancy (Owner Occupied, Second Home, Investor Owned)
-State
-Type (Fixed, Varaible)
-LTV (Loan-To-Value ratio of loan / home price)
-CLTV (Combined-Loan-To-Value ratio of all loans / home price)
-Orig Rate (Interest Rate)
-Orig Term (Length of mortgage in months)
The Unemployment data set has the following fields:
-State
-Unemployment Rate
We used the following info to connec to the database:
Server: 129.152.144.84
Service: ORCL.usuniversi01134.oraclecloud.internal
Port: 1521
Username: C##cs329e_ry2634
Password: orcl_ry2634
"
## [1] "\nThe first step is to connect to the data\nWe had 3 different data sources:\n1) MBS #1\n2) MBS #2\n3) Unemployment Rates\n\nMBS stands for Mortgage backed security. The MBS data sets are the underlying records of the mortgages that comprise the security. Each one has the fields: \n-ID (#)\n-Occupancy (Owner Occupied, Second Home, Investor Owned)\n-State\n-Type (Fixed, Varaible)\n-LTV (Loan-To-Value ratio of loan / home price)\n-CLTV (Combined-Loan-To-Value ratio of all loans / home price)\n-Orig Rate (Interest Rate)\n-Orig Term (Length of mortgage in months)\n\nThe Unemployment data set has the following fields:\n-State\n-Unemployment Rate\n\nWe used the following info to connec to the database:\nServer: 129.152.144.84\nService: ORCL.usuniversi01134.oraclecloud.internal\nPort: 1521\nUsername: C##cs329e_ry2634\nPassword: orcl_ry2634\n"
** Visualization # 1:**
Vis 1 - AVG FICO by State for both MBS #1 and MBS #2
Vis 1 - Steps to reproduce
"
Put State in columns
Put MBS #1 FICO in rows
"
## [1] "\nPut State in columns\nPut MBS #1 FICO in rows\n"
"
Set the data relationship to be by state
Change meausre values to be averages
"
## [1] "\nSet the data relationship to be by state\nChange meausre values to be averages\n"
"
Add MBS #2 to the Y axis
Add color by measure name
Filter by state
"
## [1] "\nAdd MBS #2 to the Y axis\nAdd color by measure name\nFilter by state\n"
** Visualization # 2:**
Vis 2 - Interest Rate V. Unemployment Rate by State
Vis 2 - Steps to reproduce
"
Put Occupancy in columns
Put Interest Rate in rows
Set the data relationship to be by state
"
## [1] "\nPut Occupancy in columns\nPut Interest Rate in rows\nSet the data relationship to be by state\n"
"
Added unemployment rate to the y axis
Converted measure values to be averages
"
## [1] "\nAdded unemployment rate to the y axis\nConverted measure values to be averages\n"
"Converted graph to scatterplot"
## [1] "Converted graph to scatterplot"
"
Changed shape to filled in circles
Added color by state
Added state labels
Changed the axis range
"
## [1] "\nChanged shape to filled in circles\nAdded color by state\nAdded state labels\nChanged the axis range\n"
Vis 3 - AVG CLTV by State for both MBS #1 and MBS #2
Vis 3 - Steps to reproduce
"
Put State in columns
Put MBS #1 CLTV in rows
Put MBS #2 CLTV in rows
Set the data relationship by state
"
## [1] "\nPut State in columns\nPut MBS #1 CLTV in rows\nPut MBS #2 CLTV in rows\nSet the data relationship by state\n"
"
Colored by measure names
Change measure values to be by avg
Filtered by State
Adjusted Y Axis
"
## [1] "\nColored by measure names\nChange measure values to be by avg\nFiltered by State\nAdjusted Y Axis\n"
** Visualization # 4:**
Vis 4 - FICO V. Unemployment Rate by State
Vis 4 - Steps to reproduce
"
Put State in rows
Put Unemployment Rate in columns
Set the data relationship to be by state
Add FICO to y axis
"
## [1] "\nPut State in rows\nPut Unemployment Rate in columns\nSet the data relationship to be by state\nAdd FICO to y axis\n"
"
Convert to scatterplot
Change Axis
Fill shapes
Color by state
Add label by state
"
## [1] "\nConvert to scatterplot\nChange Axis\nFill shapes\nColor by state\nAdd label by state\n"
Have a great day Mr. Li and Dr. Cannata!!!